SELECT IFNULL(cw.casedwordid, w.wordid) as wordid, IFNULL(cw.cased,w.lemma) AS lemma, ss.synsetid, ss.lexdomainid, lex.lexdomainname, (CASE WHEN ss.pos IN ('n') THEN 'noun' WHEN ss.pos IN ('v') THEN 'verb' WHEN ss.pos IN ('a','s') THEN 'adjective' WHEN ss.pos IN ('r') THEN 'adverb' ELSE ' ' END) AS pos, syn.definition AS definition_indic, ss.definition as definition_en, GROUP_CONCAT(DISTINCT CONCAT(wind.lemma,':',wind.id) SEPARATOR '|') AS lemmaset_indic, GROUP_CONCAT(DISTINCT sm.sample SEPARATOR '|') AS sampleset, GROUP_CONCAT(DISTINCT CONCAT(IF(IFNULL(cw1.cased,w1.lemma) = "purple-staining Cortinarius", NULL, IFNULL(cw1.cased,w1.lemma)),':',wen.id) SEPARATOR '|') AS lemmaset_en FROM sqlunet.wnwords w LEFT JOIN sqlunet.wnsenses s ON s.wordid=w.wordid LEFT JOIN sqlunet.wncasedwords cw ON (w.wordid=cw.wordid AND s.casedwordid=cw.casedwordid) LEFT JOIN sqlunet.wnsynsets ss ON ss.synsetid=s.synsetid LEFT JOIN sqlunet.wnlexdomains lex ON ss.lexdomainid = lex.lexdomainid LEFT JOIN sqlunet.wnsamples sm ON sm.synsetid=ss.synsetid LEFT JOIN sqlunet.wnsenses s1 ON s1.synsetid=ss.synsetid LEFT JOIN sqlunet.wncasedwords cw1 ON cw1.casedwordid=s1.casedwordid LEFT JOIN sqlunet.wnwords w1 ON w1.wordid=s1.wordid LEFT JOIN sk_synsets_kn syn ON syn.synsetid = ss.synsetid LEFT JOIN sk_senses_kn sns ON sns.synsetid = ss.synsetid LEFT JOIN sk_word_kn wind ON wind.id = sns.wordid LEFT JOIN sk_word_en wen ON w1.wordid = wen.wnwordid WHERE w.lemma LIKE "purple-staining Cortinarius" GROUP BY ss.synsetid,w.wordid, cw.casedwordid ORDER BY pos, wordid
[
{
"lemma": "purple-staining Cortinarius",
"def": [
{
"l": "purple-staining Cortinarius",
"lexname": "noun.plant",
"lexid": 20,
"pos": "noun",
"de": [
{
"id": 113096201,
"en": {
"d": "a fungus with a reddish purple cap having a smooth slimy surface; close violet gills; all parts stain dark purple when bruised",
"w": [],
"eg": []
},
"kn": {
"d": null,
"w": [],
"eg": ""
}
}
]
}
]
}
]
Sorry, exact match is not available in the bilingual dictionary.
13
Sentences with the word purple-staining
Words that rhyme with purple-staining
Sentences with the word Cortinarius
The word or phrase purple-staining Cortinarius refers to a fungus with a reddish purple cap having a smooth slimy surface; close violet gills; all parts stain dark purple when bruised. See purple-staining Cortinarius meaning in Kannada, purple-staining Cortinarius definition, translation and meaning of purple-staining Cortinarius in Kannada. Find purple-staining Cortinarius similar words, purple-staining Cortinarius synonyms. Learn and practice the pronunciation of purple-staining Cortinarius. Find the answer of what is the meaning of purple-staining Cortinarius in Kannada.
Other languages: purple-staining Cortinarius meaning in Hindi
What is purple-staining Cortinarius meaning in Kannada, purple-staining Cortinarius translation in Kannada, purple-staining Cortinarius definition, pronunciations and examples of purple-staining Cortinarius in Kannada.